ebe09f0c3d0712a7a57c7449a9a53b3f8be59c61,kie-drools-wb/kie-drools-wb-webapp/src/main/java/org/kie/workbench/drools/backend/server/DashbuilderBootstrap.java,DashbuilderBootstrap,registerDataSetDefinitions,#,59

Before Change


                        .label(DataSetTasksListGridViewImpl.COLUMN_ORGANIZATIONAL_ENTITY)
                        .buildDef());

        dataSetDefRegistry.registerDataSetDef(
                DataSetFactory.newSQLDataSetDef()
                        .uuid(PROCESS_INSTANCE_WITH_VARIABLES_DATASET)
                        .name("Domain Specific Process Instances")
                        .dataSource(jbpmDatasource)
                        .dbSQL("select pil.processInstanceId pid, pil.processId pname, v.id varid, v.variableId varname, v.value varvalue from ProcessInstanceLog pil, "
                                + "(select vil.variableId, max(vil.id) as maxvilid from VariableInstanceLog vil  group by vil.processInstanceId, vil.variableId) "
                                + "as x inner join VariableInstanceLog as v on "
                                + "v.variableId = x.variableId and v.processInstanceId = pil.processInstanceId and "
                                + "v.id = x.maxvilid", false )
                        .number("pid")
                        .label("pname" )
                        .number("varid")
                        .label("varname")
                        .label("varvalue")
                        .buildDef());

    }

After Change


                .label(DataSetTasksListGridViewImpl.COLUMN_ORGANIZATIONAL_ENTITY)
                .buildDef();

        DataSetDef processesWithVariablesDef = DataSetFactory.newSQLDataSetDef()
                        .uuid(PROCESS_INSTANCE_WITH_VARIABLES_DATASET)
                        .name("Domain Specific Process Instances")
                        .dataSource(jbpmDatasource)
                        .dbSQL("select pil.processInstanceId pid, pil.processId pname, v.id varid, v.variableId varname, v.value varvalue from ProcessInstanceLog pil, "
                                + "(select vil.variableId, max(vil.id) as maxvilid from VariableInstanceLog vil  group by vil.processInstanceId, vil.variableId) "
                                + "as x inner join VariableInstanceLog as v on "
                                + "v.variableId = x.variableId and v.processInstanceId = pil.processInstanceId and "
                                + "v.id = x.maxvilid", false )
                        .number("pid")
                        .label("pname" )
                        .number("varid")
                        .label("varname")
                        .label("varvalue")
                        .buildDef();

        // Hide all these internal data set from end user view
        humanTasksDef.setPublic(false);
        humanTasksWithUserDef.setPublic(false);
        humanTaskWithAdminDef.setPublic(false);
        processesWithVariablesDef.setPublic(false);

        // Register the data set definitions
        dataSetDefRegistry.registerDataSetDef(humanTasksDef);
        dataSetDefRegistry.registerDataSetDef(humanTasksWithUserDef);
        dataSetDefRegistry.registerDataSetDef(humanTaskWithAdminDef);
        dataSetDefRegistry.registerDataSetDef(processesWithVariablesDef);
    }

    protected void findDataSourceJNDI() {